package com.xjy.system.mapper;

import com.xjy.system.domain.SysCreditAdvance;
import com.xjy.common.core.mybatisplus.core.BaseMapperPlus;
import com.xjy.common.core.mybatisplus.cache.MybatisPlusRedisCache;
import com.xjy.system.domain.bo.SysCreditAdvanceQueryBo;
import com.xjy.system.domain.vo.SysCreditAdvanceVo;
import com.xjy.system.domain.vo.SysLoanVo;
import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

/**
 * 预付账款信息Mapper接口
 *
 * @author xjy
 * @date 2022-02-10
 */
// 如使需切换数据源 请勿使用缓存 会造成数据不一致现象
public interface SysCreditAdvanceMapper extends BaseMapperPlus<SysCreditAdvance> {

	List<SysCreditAdvanceVo> queryList(@Param("bo")SysCreditAdvanceQueryBo bo);

	List<SysCreditAdvanceVo> querySelectList();
	/*
	 * 查询 退回总额
	 * */
	BigDecimal SumAmt(String advanceNo);

	/*
	 * 查询 支付金额
	 * */
	SysCreditAdvance selectByAdvanceNo(String advanceNo);
}
